Prerequisites

Before you begin to work with Google Dataproc as a target in Qlik Replicate, make sure that the following prerequisites have been met:

• General:

  • The storage location must be accessible from the Qlik Replicate machine.
  • The user specified in the Google Dataproc target endpoint's Hive access settings must have access to HiveServer2.

• ODBC Driver (Windows and Linux): Install Cloudera ODBC driver for Apache Hive 2.6.9 or later, or any other Google Dataproc compatible driver on the Replicate Server machine.

• Bucket and folder permissions: The JSON Credentials specified in the Google Dataproc endpoint's Google Cloud Storage settings must be for an account that has read and write access to the specified bucket and target folder.

• Hive table permissions: Replicate requires permissions to perform the following operations on Hive tables: CREATE, DROP, DESCRIBE, and ALTER table. ALTER table may also include RENAME table, ADD/RENAME column, and CREATE/DROP partitions on tables.